'''
cursor = client.cusor(pymysql.cursors.DictCursor)
cursor = clent.cursor(pymysql.cursors.DictCursor)
cursor = client.cursor(pymysql.cursors.DictCursor)
cursor = client.cursor(pymysq.cursors.DictCursor)
cursor = client.cursor(pymysql.cursor.DictCursor)
cursor = client.curosr(pymysql.cursor.DictCursor)

cursor.fethcone()
cursor.fetchone()
cursor.fetchone()
cursor.fetchone()
cursor.fetchone()
cursor.fetchone()
cursor.fetchone()
cursor.fetchone()
cursor.fetchone()
cursor.fetchone()
res=cursor.fetchone()
res = cursor.fetchone()
res = cursorlfetchone()
res = cursor.fetchone()
res = cursor.fetchone()
res = cursor.fetchone()
res = cursor.fetchone()
res = cursor.fetchone()
res.= cursor.fetchone()
res = cursor.fetchone()
res = cursor.fetchone()
rea = cursor.fetchone()
res = cursor.fetchone()
res = cursor.fetchone()
res = cursor.fetchone()

cursor = client.cursor(pymysql.cursors.DictCursor())
res = cursor.fetchmany(2)
res = cursor.fetchmany(1)
res = cursor.fetchmany(3)
res = cursor.fetchmany(3)
res = cursor.fetchmany(2)
res = cursor.fetchmany(1)
res = cursor.fetchmany(2)
res = cursor.fetchmnay(3)
res = cursor.fetchmany(1)
res = cursor.fetchmany(2)
res = cursor.fetchmany(3)

print(cursor.fetchall())
print(cursor.scroll(0,mode='absolute'))
print(cursor.fetchall())
print(cursor.croll(1,mode='absolute'))
print(cursor.fetchall())
cursor.scroll(0,mode='absolute')
print(cursro.fetchall())

print(cursor.fetchall())
cursor.scroll(0,mode='absolute')
print(cursor.fetchall)

print(cursor.fetchall())
cursor.scroll(0,mode='absolute')
print(cursor.fetchall())

print(cursor.fetchall())
cursor.scroll(0,mode='absolute')
print(cursor.fetchall())
cursor.scroll(1,mode='absolute')
print(cursor.fetchall())
cursor.scroll(1,mode='absolute')
print(cursor.fetchall())
cursor.scroll(0,mode='absolute')
print(cursor.fetchall())
cursor.scroll(0,mode='absolute')
print(cursor.fetchall())
cursor.scroll(0,mode='absolute')
print(cursor.fetchall)

print(cursor.fetchone())
cursor.scroll(1,mode='relative')
print(cursor.fetchone())

cursor.execute(sql)
cursor.fetchone()
cursor.scroll(1,mode='relative')
cursor.fetchone()

cursor.execute(sql)
cursor.fetchone()
cursor.scroll(1.mode='relative')
cursor.fetchone()

cursor.execute(sql)
cursor.fetchone()
cursor.scroll(1,mode='relative')
cursor.fetchone()
cursor.execute(sql)
cursor.fetchone()
cursor.scroll(1,mode='relative')
cursor.fetchone()

cursor.execute(sql)
cursor.fetchone()
cursor.scroll(1,mode='relative')
cursor.fetchone()

cursor.execute(sql)
cursor.fetchone()
cursor.scroll(1.mode='relative')
cursor.fetchone()

cursor.execute(sql)
cursor.fetchone()
cursor.scroll(1,mode='relative')
cursor.fetchone()

sql ='create view dahai_view as select * from emp where name = '大海''
sql = 'create view dahai_view as select * from emp where name = '大海''
sql = 'create view dahai_view as select * from emp where name = '大海''
sql = 'create view xishi_view as select * from emp where name = '西施''
sql = 'create view dahai_view as select * from emp where name = '大海''
sql = 'create view xishi_view as select * from emp where name = '西施''
sql = 'create view dahai_view as select * from em where name = "大海"'
sql = 'create view xishi_view as select * from emp where name = "西施"'
sql = 'create view dahai_view as select * from emp where name ="大海"'
sql = 'create view xishi_view as select * from emp where name="西施"'
sql = 'create view dahai_view asselect * from emp where name ="大海"'
sql = 'create view xishi_view as select * from emp where name ="西施"'
sql = 'create view dahai_view as select * from emp where name ="大海"'
sql = 'create view _xishi_view as select * from emp where name = "西施"'
sql = 'create view dahai_view as select * from emp where name = "大海"'
sql = 'create view xishi_view as select * from em where name = "西施"'
sql = 'create view dahai_view as select * from emp where name = "大海"'
sql = 'create view xishi_view as select * from emp where name = "西施"'
sql = 'create view dahai_view as select * from emp where name = :大海:'
sql = 'create view xishi_view as select *from emp where name = "西施"'
sql = 'create view dahai_view as select * from emp where name ="大海"'
sql = 'create view xishi_view as select * from emp where name ="西施"'

sql = 'create view jisu_view as select emp1.*,dep.name as dep_name form emp inner join dep on emp1.dep_id = dep.id where dep.name = "技术"'
sql = 'create view jisu_view as select emp1.* dep.name as dep_name from emp1 inner join dep on emp1.dep_id = dep.id where dep.name = "技术"'

redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw\
redis-cli --raw
redis-cli --raw\redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --rawredis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-ci --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
resis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cle--raw
redis-cli --rw
redis-cli --raw
redis-cli --raw
redis-cli --rawr
redis-cli --raw
redis-cli --raw
redis-cli --raw
redis-cli --raw

redis-cli --raw


select 1
select 1
select 1
set age 11
get age
slelect 1
set age 11
get age
select 1
set age 11
get age
select 1
set age 11
get age
select 1 set age 11
get age
select 1
set age 11
get age
select set age 11
get age
select 1
set age 11
get age
select 1
set age 11
get age
select 1
set age 11
get age
select 1 set age get age
select 1
set age 11
get age
select 1
set age 11
get age
select 1 set age 11 get age
select 1
set age 11
get age
sselect 1
set age 11
get age
select 1
set age 11
get age
select 1
set age 11
get age
select 1
set age 11
get age
select 1
set age 11
get ag2
select 1set age 11
get age
select 1
set age 11
set name huge
get age
get name
select 1
set age 11
set name huge
mget age name
select 1
mset age 11 name huge
mget age name
select 1
mset age 11 name huge
mget age name
select 1
mset age 11 name huge
mget age name
select 1mset age 11 name hug
mget age name
select 2
mset age 11 name huge
mget age name
select 3
mset age 11 name huge
mget age name
select 5
mset age 11 name huge
mget age name
select 5
mset age 22 name dahai
exit










'''
from keyword import iskeyword

